package PRSystem_javaSql;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

public class PRSystem_connection_xxxxx {
	
	
	private static String DRV = "oracle.jdbc.driver.OracleDriver";
	private static String URL = "jdbc:oracle:thin:@112.216.253.124:1521:xe";
	private static String USR =  "jhlee183";
	private static String PWD =  "jhlee183";
	

	// 접속 만 가능
	public Connection makeConn() throws Exception {
	Connection conn = null;
		
	
	Class.forName(DRV);
	conn = DriverManager.getConnection(URL,USR,PWD);
		
	
	return conn;
	}
	
	
	
	
	// sql = ADSF 문~
	// 입력값... 조회 대상  vo 받아 오기
	//pstmt = conn.prepareStatement(selectSQL);
	
	
	
	
	
	//PRSystem_connection a = new closeConn(conn,prep,resu); 이 문장으로 호출 
	private void closeConn(Connection conn,PreparedStatement prep, ResultSet resu) {
		if ( resu != null ) try { } catch (Exception e) { }
		if ( prep != null ) try { } catch (Exception e) { }
		if ( conn != null ) try { } catch (Exception e) { }
	}
	
	
	
	
	
	

}
